package club.easin.sq.dao;

import club.easin.sq.dto.HouseQueryDto;
import club.easin.sq.dto.InmateQueryDto;
import club.easin.sq.dto.SqHouse;
import club.easin.sq.dto.SqInmate;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

@Repository("SqHouseMapper")
@org.apache.ibatis.annotations.Mapper
public interface SqHouseMapper extends Mapper<SqHouse> {

    public Page<SqHouse> getGrildHouse(HouseQueryDto dto);
    public int addInmateToHouse(@Param("houserid") String houseid,@Param("inmateid")String inmateid);
    public List<SqInmate> getInamteByHouse(String houseid);
    public int delHouseInmate(@Param("houseid")String houseid,@Param("inmateid")String inmateid);
    public int getInmateCount(String houseid);
}